Let's start answering the questions asked

1. Total revenue current year

2. New Customer revenue

3. Existing customer growth

4. Revenue lost from attrition

5. Existing customer revenue current year

6. Existing Customer Revenue Prior Year

7. Total Customers Current Year

8. Total Customers Previous year

9. New Customers

10. Lost Customers

Visualization

Here, we can see the pattern that 2016 was not a good year for the company as we had drop in revenue due to drop in number of customers

Above, for the year 2015, we would consider all customers as new customer. Here, we can see that almost same number of customers stayed in 2016 and 2017, but in 2017, more customers were added.